CREATE TABLE [lgw].[Customer_Address]
(
[AddressId] [bigint] NOT NULL IDENTITY(1, 1),
[CustomerId] [bigint] NOT NULL,
[FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiddleName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AddressTypeid] [bigint] NULL,
[Address1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__Customer___State__0A338187] DEFAULT ('AP'),
[Country] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__Customer___Count__0B27A5C0] DEFAULT ('IND'),
[Zip1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Zip2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isPrimary] [bit] NOT NULL,
[CreatedUser] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF__Customer___Creat__084B3915] DEFAULT (getdate()),
[UpdatedUser] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatedDate] [datetime] NOT NULL CONSTRAINT [DF__Customer___Updat__093F5D4E] DEFAULT (getdate())
) ON [PRIMARY]
GO
